<?php
//Connection statement
require_once('Connections/cn.php');

// begin Recordset
$query_Recordset1 = "SELECT ID_CATEGORIA, NOMBRE_CATEGORIA FROM categoria";
$Recordset1 = $cn->SelectLimit($query_Recordset1) or die($cn->ErrorMsg());
$totalRows_Recordset1 = $Recordset1->RecordCount();
// end Recordset
?><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<?php //PHP ADODB document - made with PHAkt 3.6.0?>
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<title>Untitled Document</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>

<body>
<label for="select">Categoria a la que pertenece</label>
<select name="catPadre" id="catPadre">
  <?php
  while(!$Recordset1->EOF){
?>
  <option value="<?php echo $Recordset1->Fields('ID_CATEGORIA')?>"><?php echo $Recordset1->Fields('NOMBRE_CATEGORIA')?></option>
  <?php
    $Recordset1->MoveNext();
  }
  $Recordset1->MoveFirst();
?>
</select>
</body>
</html>
<?php
$Recordset1->Close();
?>
